Skip to main content Skip to complementary content

Supported Data Types

The following table shows the Google Cloud BigQuery data warehouse data types that are supported when using Qlik Compose and the default mapping from Qlik Compose data types.

For information on how to view the data type that is mapped from the source, see the section for the source database you are using.

Compose Data Type

BigQuery Data Type

BYTES

BYTES

DATE

DATE    

TIME

TIME  

DATETIME

If scale <=6:

TIMESTAMP If scale >6:

STRING

BIGINT

INTEGER

DECIMAL

If the data can be stored in 38,9, then:

NUMERIC

If not, then:

STRING with length of original precision +2

VARCHAR

STRING

INTEGER

INTEGER

Unsupported Data Types

The following Google Cloud BigQuery data types are not supported:

GEOGRAPHY, STRUCT, and ARRAY.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!